<!DOCTYPE html><html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" data-whc_version="25.0">
    <head><link rel="shortcut icon" href="../../../oxygen-webhelp/template/images/favicon.png"/><link rel="icon" href="../../../oxygen-webhelp/template/images/favicon.png"/><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/><meta name="viewport" content="width=device-width, initial-scale=1.0"/><meta http-equiv="X-UA-Compatible" content="IE=edge"/><meta name="copyright" content="(C) Copyright 2024"/><meta name="generator" content="DITA-OT"/><meta name="description" content="The Oracle destination writes data to tables in a Oracle database. For information about supported versions, see Supported Systems and Versions . You can use the Oracle destination to write new data ..."/><meta name="prodname" content="Data Collector"/><meta name="version" content="3"/><meta name="release" content="16"/><meta name="modification" content="0"/>        
      <title>Oracle</title><!--  Generated with Oxygen version 25.1, build number 2023042410.  --><meta name="wh-path2root" content="../../../"/><meta name="wh-toc-id" content="concept_shv_2jd_r1c-d16893e52396"/><meta name="wh-source-relpath" content="datacollector/UserGuide/Destinations/Oracle.dita"/><meta name="wh-out-relpath" content="datacollector/UserGuide/Destinations/Oracle.html"/>

    <link rel="stylesheet" type="text/css" href="../../../oxygen-webhelp/app/commons.css?buildId=2023042410"/>
    <link rel="stylesheet" type="text/css" href="../../../oxygen-webhelp/app/topic.css?buildId=2023042410"/>

    <script src="../../../oxygen-webhelp/app/options/properties.js?buildId=20240802104629"></script>
    <script src="../../../oxygen-webhelp/app/localization/strings.js?buildId=2023042410"></script>
    <script src="../../../oxygen-webhelp/app/search/index/keywords.js?buildId=20240802104629"></script>
    <script defer="defer" src="../../../oxygen-webhelp/app/commons.js?buildId=2023042410"></script>
    <script defer="defer" src="../../../oxygen-webhelp/app/topic.js?buildId=2023042410"></script>
<link rel="stylesheet" type="text/css" href="../../../oxygen-webhelp/template/light.css?buildId=2023042410"/><link rel="stylesheet" type="text/css" href="../../../skin.css"/></head>

    <body class="wh_topic_page frmBody">
        
        
        

        
<nav class="navbar navbar-default wh_header" data-whc_version="25.0">
    <div class="container-fluid">
        <div class="wh_header_flex_container navbar-nav navbar-expand-md navbar-dark">
            <div class="wh_logo_and_publication_title_container">
                <div class="wh_logo_and_publication_title">
                    
                    <!--
                            This component will be generated when the next parameters are specified in the transformation scenario:
                            'webhelp.logo.image' and 'webhelp.logo.image.target.url'.
                            See: http://oxygenxml.com/doc/versions/17.1/ug-editor/#topics/dita_webhelp_output.html.
                    -->
                    
                    <div class=" wh_publication_title "><a href="../../../index.html"><span class="booktitle">  <span class="ph mainbooktitle"><span class="ph">Data Collector</span> User Guide</span>  </span></a></div>
                    
                </div>
                
                <!-- The menu button for mobile devices is copied in the output only when the 'webhelp.show.top.menu' parameter is set to 'yes' -->
                
            </div>

            <div class="wh_top_menu_and_indexterms_link collapse navbar-collapse">
                
                
                <div class=" wh_indexterms_link "><a href="../../../indexTerms.html" title="Index" aria-label="Go to index terms page"><span>Index</span></a></div>
                
            </div>
        </div>
    </div>
</nav>

        <div class=" wh_search_input navbar-form wh_topic_page_search search " role="form">


<form id="searchForm" method="get" role="search" action="../../../search.html"><div><input type="search" placeholder="Search " class="wh_search_textfield" id="textToSearch" name="searchQuery" aria-label="Search query" required="required"/><button type="submit" class="wh_search_button" aria-label="Search"><span class="search_input_text">Search</span></button></div></form>

</div>
        
        <div class="container-fluid">
            <div class="row">

                <nav class="wh_tools d-print-none">
                    
<div data-tooltip-position="bottom" class=" wh_breadcrumb "><ol class="d-print-none"><li><span class="home"><a href="../../../index.html"><span>Home</span></a></span></li><li><div class="topicref" data-id="concept_agj_cfj_br"><div class="title"><a href="../../../datacollector/UserGuide/Destinations/Destinations-title.html">Destinations</a></div></div></li><li class="active"><div class="topicref" data-id="concept_shv_2jd_r1c"><div class="title"><a href="../../../datacollector/UserGuide/Destinations/Oracle.html#concept_shv_2jd_r1c">Oracle</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li></ol></div>



                    <div class="wh_right_tools "><button class="wh_hide_highlight" aria-label="Toggle search highlights" title="Toggle search highlights"></button><button class="webhelp_expand_collapse_sections" data-next-state="collapsed" aria-label="Collapse sections" title="Collapse sections"></button><div class=" wh_navigation_links "><span id="topic_navigation_links" class="navheader">
  
<span class="navprev"><a class="- topic/link link" href="../../../datacollector/UserGuide/Destinations/NamedPipe.html#concept_pl5_tdg_gcb" title="Named Pipe" aria-label="Previous topic: Named Pipe" rel="prev"></a></span>  
<span class="navnext"><a class="- topic/link link" href="../../../datacollector/UserGuide/Destinations/PulsarProducer.html#concept_fq3_kpc_r2b" title="Pulsar Producer" aria-label="Next topic: Pulsar Producer" rel="next"></a></span>  </span></div>
<!--External resource link-->
<div class=" wh_print_link print d-none d-md-inline-block "><button onClick="window.print()" title="Print this page" aria-label="Print this page"></button></div>
                        
                        
                        
                        
                    </div>
                </nav>
            </div>

            

<div class="wh_content_area">
                <div class="row">
                    


                        <nav role="navigation" id="wh_publication_toc" class="col-lg-3 col-md-3 col-sm-12 d-md-block d-none d-print-none">
<div id="wh_publication_toc_content">


                            <div class=" wh_publication_toc " data-tooltip-position="right"><span class="expand-button-action-labels"><span id="button-expand-action" role="button" aria-label="Expand"></span><span id="button-collapse-action" role="button" aria-label="Collapse"></span><span id="button-pending-action" role="button" aria-label="Pending"></span></span><ul role="tree" aria-label="Table of Contents"><li role="treeitem" aria-expanded="false"><div data-tocid="concept_htw_ghg_jq-d16893e53" class="topicref" data-id="concept_htw_ghg_jq" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_htw_ghg_jq-d16893e53-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Getting_Started/GettingStarted_Title.html#concept_htw_ghg_jq" id="concept_htw_ghg_jq-d16893e53-link">Getting Started</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_l2v_nlp_mpb-d16893e331" class="topicref" data-id="concept_l2v_nlp_mpb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_l2v_nlp_mpb-d16893e331-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/ReleaseNotes/ReleaseNotes.html#concept_l2v_nlp_mpb" id="concept_l2v_nlp_mpb-d16893e331-link">Release Notes</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_l4q_flb_kr-d16893e2582" class="topicref" data-id="concept_l4q_flb_kr" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_l4q_flb_kr-d16893e2582-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Installation/Install_title.html" id="concept_l4q_flb_kr-d16893e2582-link">Installation</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_ylh_yyz_ky-d16893e3984" class="topicref" data-id="concept_ylh_yyz_ky" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_ylh_yyz_ky-d16893e3984-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Configuration/Config_title.html" id="concept_ylh_yyz_ky-d16893e3984-link">Configuration</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_ejk_f1f_5v-d16893e7058" class="topicref" data-id="concept_ejk_f1f_5v" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_ejk_f1f_5v-d16893e7058-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Upgrade/Upgrade_title.html" id="concept_ejk_f1f_5v-d16893e7058-link">Upgrade</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_qsw_cjy_bt-d16893e10103" class="topicref" data-id="concept_qsw_cjy_bt" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_qsw_cjy_bt-d16893e10103-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Pipeline_Design/PipelineDesign_title.html" id="concept_qsw_cjy_bt-d16893e10103-link">Pipeline Concepts and Design</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_qn1_wn4_kq-d16893e11199" class="topicref" data-id="concept_qn1_wn4_kq" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_qn1_wn4_kq-d16893e11199-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Pipeline_Configuration/PipelineConfiguration_title.html" id="concept_qn1_wn4_kq-d16893e11199-link">Pipeline Configuration</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_hdr_gyw_41b-d16893e13057" class="topicref" data-id="concept_hdr_gyw_41b" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_hdr_gyw_41b-d16893e13057-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Data_Formats/DataFormats-Title.html" id="concept_hdr_gyw_41b-d16893e13057-link">Data Formats</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_yjl_nc5_jq-d16893e14164" class="topicref" data-id="concept_yjl_nc5_jq" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_yjl_nc5_jq-d16893e14164-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Origins/Origins_title.html" id="concept_yjl_nc5_jq-d16893e14164-link">Origins</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_yjl_nc5_jq-d16893e35197" class="topicref" data-id="concept_yjl_nc5_jq" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_yjl_nc5_jq-d16893e35197-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Processors/Processors_title.html" id="concept_yjl_nc5_jq-d16893e35197-link">Processors</a></div></div></li><li role="treeitem" aria-expanded="true"><div data-tocid="concept_agj_cfj_br-d16893e44037" class="topicref" data-id="concept_agj_cfj_br" data-state="expanded"><span role="button" tabindex="0" aria-labelledby="button-collapse-action concept_agj_cfj_br-d16893e44037-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/Destinations-title.html" id="concept_agj_cfj_br-d16893e44037-link">Destinations</a></div></div><ul role="group" class="navbar-nav nav-list"><li role="treeitem"><div data-tocid="concept_hpr_twm_jq-d16893e44059" class="topicref" data-id="concept_hpr_twm_jq" data-state="leaf"><span role="button" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/Destinations_overview.html#concept_hpr_twm_jq" id="concept_hpr_twm_jq-d16893e44059-link">Destinations</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_gyq_rpr_4cb-d16893e44083" class="topicref" data-id="concept_gyq_rpr_4cb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_gyq_rpr_4cb-d16893e44083-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/Aerospike.html#concept_gyq_rpr_4cb" id="concept_gyq_rpr_4cb-d16893e44083-link">Aerospike (deprecated)</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_ibv_yj4_qxb-d16893e44129" class="topicref" data-id="concept_ibv_yj4_qxb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_ibv_yj4_qxb-d16893e44129-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/AerospikeClient.html#concept_ibv_yj4_qxb" id="concept_ibv_yj4_qxb-d16893e44129-link">Aerospike Client</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_avx_bnq_rt-d16893e44245" class="topicref" data-id="concept_avx_bnq_rt" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_avx_bnq_rt-d16893e44245-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/AmazonS3.html#concept_avx_bnq_rt" id="concept_avx_bnq_rt-d16893e44245-link">Amazon S3</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_ggg_4wy_41c-d16893e44533" class="topicref" data-id="concept_ggg_4wy_41c" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_ggg_4wy_41c-d16893e44533-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/AzureBlobStorage.html#concept_ggg_4wy_41c" id="concept_ggg_4wy_41c-d16893e44533-link">Azure Blob Storage</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_jzm_kf4_zx-d16893e44699" class="topicref" data-id="concept_jzm_kf4_zx" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_jzm_kf4_zx-d16893e44699-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/DataLakeStore.html#concept_jzm_kf4_zx" id="concept_jzm_kf4_zx-d16893e44699-link">Azure Data Lake Storage (Legacy) (deprecated)</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_xzc_wfq_xhb-d16893e44968" class="topicref" data-id="concept_xzc_wfq_xhb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_xzc_wfq_xhb-d16893e44968-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/ADLS-G1-D.html#concept_xzc_wfq_xhb" id="concept_xzc_wfq_xhb-d16893e44968-link">Azure Data Lake Storage Gen1 (deprecated)</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_ajp_1d2_vhb-d16893e45258" class="topicref" data-id="concept_ajp_1d2_vhb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_ajp_1d2_vhb-d16893e45258-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/ADLS-G2-D.html#concept_ajp_1d2_vhb" id="concept_ajp_1d2_vhb-d16893e45258-link">Azure Data Lake Storage Gen2</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_xq5_d5q_1bb-d16893e45549" class="topicref" data-id="concept_xq5_d5q_1bb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_xq5_d5q_1bb-d16893e45549-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/AzureEventHubProducer.html#concept_xq5_d5q_1bb" id="concept_xq5_d5q_1bb-d16893e45549-link">Azure Event Hub Producer</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_pnd_jkq_1bb-d16893e45617" class="topicref" data-id="concept_pnd_jkq_1bb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_pnd_jkq_1bb-d16893e45617-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/AzureIoTHub.html#concept_pnd_jkq_1bb" id="concept_pnd_jkq_1bb-d16893e45617-link">Azure IoT Hub Producer</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_hjv_5nn_r3b-d16893e45716" class="topicref" data-id="concept_hjv_5nn_r3b" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_hjv_5nn_r3b-d16893e45716-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/AzureSynapse.html#concept_hjv_5nn_r3b" id="concept_hjv_5nn_r3b-d16893e45716-link">Azure Synapse SQL</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_hfy_mfd_sr-d16893e46145" class="topicref" data-id="concept_hfy_mfd_sr" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_hfy_mfd_sr-d16893e46145-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/Cassandra.html#concept_hfy_mfd_sr" id="concept_hfy_mfd_sr-d16893e46145-link">Cassandra</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_hw5_s3n_sz-d16893e46279" class="topicref" data-id="concept_hw5_s3n_sz" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_hw5_s3n_sz-d16893e46279-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/CoAPClient.html#concept_hw5_s3n_sz" id="concept_hw5_s3n_sz-d16893e46279-link">CoAP Client</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_ahq_1wq_h2b-d16893e46347" class="topicref" data-id="concept_ahq_1wq_h2b" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_ahq_1wq_h2b-d16893e46347-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/Couchbase.html#concept_ahq_1wq_h2b" id="concept_ahq_1wq_h2b-d16893e46347-link">Couchbase</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_ddy_cdz_clb-d16893e46461" class="topicref" data-id="concept_ddy_cdz_clb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_ddy_cdz_clb-d16893e46461-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/DeltaLake.html#concept_ddy_cdz_clb" id="concept_ddy_cdz_clb-d16893e46461-link">Databricks Delta Lake</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_u5t_vpv_4r-d16893e46869" class="topicref" data-id="concept_u5t_vpv_4r" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_u5t_vpv_4r-d16893e46869-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/Elasticsearch.html#concept_u5t_vpv_4r" id="concept_u5t_vpv_4r-d16893e46869-link">Elasticsearch</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_pzn_hl4_yr-d16893e47009" class="topicref" data-id="concept_pzn_hl4_yr" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_pzn_hl4_yr-d16893e47009-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/Flume.html#concept_pzn_hl4_yr" id="concept_pzn_hl4_yr-d16893e47009-link">Flume (deprecated)</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_hj4_brk_dbb-d16893e47077" class="topicref" data-id="concept_hj4_brk_dbb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_hj4_brk_dbb-d16893e47077-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/BigQuery.html#concept_hj4_brk_dbb" id="concept_hj4_brk_dbb-d16893e47077-link">Google BigQuery (Legacy) (deprecated)</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_nfr_by1_3rb-d16893e47173" class="topicref" data-id="concept_nfr_by1_3rb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_nfr_by1_3rb-d16893e47173-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/GBigQuery.html#concept_nfr_by1_3rb" id="concept_nfr_by1_3rb-d16893e47173-link">Google BigQuery</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_pl5_tmq_tx-d16893e47559" class="topicref" data-id="concept_pl5_tmq_tx" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_pl5_tmq_tx-d16893e47559-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/Bigtable.html#concept_pl5_tmq_tx" id="concept_pl5_tmq_tx-d16893e47559-link">Google Bigtable</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_p4n_jrl_nbb-d16893e47777" class="topicref" data-id="concept_p4n_jrl_nbb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_p4n_jrl_nbb-d16893e47777-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/GCS.html#concept_p4n_jrl_nbb" id="concept_p4n_jrl_nbb-d16893e47777-link">Google Cloud Storage</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_qsj_hk1_v1b-d16893e48000" class="topicref" data-id="concept_qsj_hk1_v1b" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_qsj_hk1_v1b-d16893e48000-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/PubSubPublisher.html#concept_qsj_hk1_v1b" id="concept_qsj_hk1_v1b-d16893e48000-link">Google Pub/Sub Publisher</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_qjf_xdz_q3b-d16893e48090" class="topicref" data-id="concept_qjf_xdz_q3b" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_qjf_xdz_q3b-d16893e48090-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/GPSS.html#concept_qjf_xdz_q3b" id="concept_qjf_xdz_q3b-d16893e48090-link">GPSS Producer (deprecated)</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_awl_4km_zq-d16893e48226" class="topicref" data-id="concept_awl_4km_zq" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_awl_4km_zq-d16893e48226-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/HadoopFS-destination.html#concept_awl_4km_zq" id="concept_awl_4km_zq-d16893e48226-link">Hadoop FS</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_wsz_5t5_vr-d16893e48561" class="topicref" data-id="concept_wsz_5t5_vr" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_wsz_5t5_vr-d16893e48561-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/HBase.html#concept_wsz_5t5_vr" id="concept_wsz_5t5_vr-d16893e48561-link">HBase</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_gcr_z2t_zv-d16893e48732" class="topicref" data-id="concept_gcr_z2t_zv" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_gcr_z2t_zv-d16893e48732-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/HiveMetastore.html#concept_gcr_z2t_zv" id="concept_gcr_z2t_zv-d16893e48732-link">Hive Metastore</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_kvs_3hh_ht-d16893e48985" class="topicref" data-id="concept_kvs_3hh_ht" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_kvs_3hh_ht-d16893e48985-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/Hive.html#concept_kvs_3hh_ht" id="concept_kvs_3hh_ht-d16893e48985-link">Hive Streaming (deprecated)</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_khl_sg5_lz-d16893e49053" class="topicref" data-id="concept_khl_sg5_lz" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_khl_sg5_lz-d16893e49053-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/HTTPClient.html#concept_khl_sg5_lz" id="concept_khl_sg5_lz-d16893e49053-link">HTTP Client</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_inf_db_sr-d16893e49363" class="topicref" data-id="concept_inf_db_sr" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_inf_db_sr-d16893e49363-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/InfluxDB.html#concept_inf_db_sr" id="concept_inf_db_sr-d16893e49363-link">InfluxDB</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_s4q_mfn_crb-d16893e49409" class="topicref" data-id="concept_s4q_mfn_crb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_s4q_mfn_crb-d16893e49409-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/InfluxDB2.html#concept_s4q_mfn_crb" id="concept_s4q_mfn_crb-d16893e49409-link">InfluxDB 2.x</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_kvs_3hh_ht-d16893e49457" class="topicref" data-id="concept_kvs_3hh_ht" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_kvs_3hh_ht-d16893e49457-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/JDBCProducer.html#concept_kvs_3hh_ht" id="concept_kvs_3hh_ht-d16893e49457-link">JDBC Producer</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_yrx_lr3_qbc-d16893e49621" class="topicref" data-id="concept_yrx_lr3_qbc" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_yrx_lr3_qbc-d16893e49621-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/JiraD.html#concept_yrx_lr3_qbc" id="concept_yrx_lr3_qbc-d16893e49621-link">Jira</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_sfz_ww5_n1b-d16893e49742" class="topicref" data-id="concept_sfz_ww5_n1b" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_sfz_ww5_n1b-d16893e49742-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/JMSProducer.html#concept_sfz_ww5_n1b" id="concept_sfz_ww5_n1b-d16893e49742-link">JMS Producer</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_oq2_5jl_zq-d16893e49923" class="topicref" data-id="concept_oq2_5jl_zq" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_oq2_5jl_zq-d16893e49923-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/KProducer.html#concept_oq2_5jl_zq" id="concept_oq2_5jl_zq-d16893e49923-link">Kafka Producer</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_bjv_dpk_kv-d16893e50153" class="topicref" data-id="concept_bjv_dpk_kv" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_bjv_dpk_kv-d16893e50153-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/KinFirehose.html#concept_bjv_dpk_kv" id="concept_bjv_dpk_kv-d16893e50153-link">Kinesis Firehose</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_swk_h1j_yr-d16893e50268" class="topicref" data-id="concept_swk_h1j_yr" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_swk_h1j_yr-d16893e50268-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/KinProducer.html#concept_swk_h1j_yr" id="concept_swk_h1j_yr-d16893e50268-link">Kinesis Producer</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_hxh_5xg_qbb-d16893e50402" class="topicref" data-id="concept_hxh_5xg_qbb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_hxh_5xg_qbb-d16893e50402-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/KineticaDB.html#concept_hxh_5xg_qbb" id="concept_hxh_5xg_qbb-d16893e50402-link">KineticaDB (deprecated)</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_chy_xxg_4v-d16893e50492" class="topicref" data-id="concept_chy_xxg_4v" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_chy_xxg_4v-d16893e50492-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/Kudu.html#concept_chy_xxg_4v" id="concept_chy_xxg_4v-d16893e50492-link">Kudu </a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_zvc_bv5_1r-d16893e50606" class="topicref" data-id="concept_zvc_bv5_1r" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_zvc_bv5_1r-d16893e50606-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/LocalFS.html#concept_zvc_bv5_1r" id="concept_zvc_bv5_1r-d16893e50606-link">Local FS</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_vxg_w2z_yv-d16893e50828" class="topicref" data-id="concept_vxg_w2z_yv" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_vxg_w2z_yv-d16893e50828-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/MapRDB.html#concept_vxg_w2z_yv" id="concept_vxg_w2z_yv-d16893e50828-link">MapR DB</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_i4h_2kj_dy-d16893e50999" class="topicref" data-id="concept_i4h_2kj_dy" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_i4h_2kj_dy-d16893e50999-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/MapRDBJSON.html#concept_i4h_2kj_dy" id="concept_i4h_2kj_dy-d16893e50999-link">MapR DB JSON</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_spv_xlc_fv-d16893e51161" class="topicref" data-id="concept_spv_xlc_fv" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_spv_xlc_fv-d16893e51161-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/MapRFS.html#concept_spv_xlc_fv" id="concept_spv_xlc_fv-d16893e51161-link">MapR FS </a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_cfj_qbn_2v-d16893e51459" class="topicref" data-id="concept_cfj_qbn_2v" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_cfj_qbn_2v-d16893e51459-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/MapRStreamsProd.html#concept_cfj_qbn_2v" id="concept_cfj_qbn_2v-d16893e51459-link">MapR Streams Producer</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_kvs_3hh_ht-d16893e51606" class="topicref" data-id="concept_kvs_3hh_ht" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_kvs_3hh_ht-d16893e51606-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/MemSQLLoader.html#concept_kvs_3hh_ht" id="concept_kvs_3hh_ht-d16893e51606-link">MemSQL Fast Loader (deprecated)</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_eth_k5n_4v-d16893e51741" class="topicref" data-id="concept_eth_k5n_4v" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_eth_k5n_4v-d16893e51741-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/MongoDB.html#concept_eth_k5n_4v" id="concept_eth_k5n_4v-d16893e51741-link">MongoDB</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_kr3_kqt_n5b-d16893e51875" class="topicref" data-id="concept_kr3_kqt_n5b" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_kr3_kqt_n5b-d16893e51875-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/MongoDBAtlas-D.html#concept_kr3_kqt_n5b" id="concept_kr3_kqt_n5b-d16893e51875-link">MongoDB Atlas</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_odz_txt_lz-d16893e52107" class="topicref" data-id="concept_odz_txt_lz" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_odz_txt_lz-d16893e52107-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/MQTTPublisher.html#concept_odz_txt_lz" id="concept_odz_txt_lz-d16893e52107-link">MQTT Publisher</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_pl5_tdg_gcb-d16893e52222" class="topicref" data-id="concept_pl5_tdg_gcb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_pl5_tdg_gcb-d16893e52222-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/NamedPipe.html#concept_pl5_tdg_gcb" id="concept_pl5_tdg_gcb-d16893e52222-link">Named Pipe</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="true" class="active"><div data-tocid="concept_shv_2jd_r1c-d16893e52396" class="topicref" data-id="concept_shv_2jd_r1c" data-state="expanded"><span role="button" tabindex="0" aria-labelledby="button-collapse-action concept_shv_2jd_r1c-d16893e52396-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/Oracle.html#concept_shv_2jd_r1c" id="concept_shv_2jd_r1c-d16893e52396-link">Oracle</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div><ul role="group" class="navbar-nav nav-list"><li role="treeitem"><div data-tocid="concept_msy_vsl_fcc-d16893e52420" class="topicref" data-id="concept_msy_vsl_fcc" data-state="leaf"><span role="button" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/Oracle.html#concept_msy_vsl_fcc" id="concept_msy_vsl_fcc-d16893e52420-link">Prerequisite</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_ntt_c2h_z1c-d16893e52444" class="topicref" data-id="concept_ntt_c2h_z1c" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_ntt_c2h_z1c-d16893e52444-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/Oracle.html#concept_ntt_c2h_z1c" id="concept_ntt_c2h_z1c-d16893e52444-link">Enabling Data Drift Handling</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem"><div data-tocid="concept_v5v_pfh_z1c-d16893e52492" class="topicref" data-id="concept_v5v_pfh_z1c" data-state="leaf"><span role="button" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/Oracle.html#concept_v5v_pfh_z1c" id="concept_v5v_pfh_z1c-d16893e52492-link">Creating Tables</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem"><div data-tocid="concept_ezq_nhh_z1c-d16893e52516" class="topicref" data-id="concept_ezq_nhh_z1c" data-state="leaf"><span role="button" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/Oracle.html#concept_ezq_nhh_z1c" id="concept_ezq_nhh_z1c-d16893e52516-link">CRUD Operation Processing</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem"><div data-tocid="task_fbj_hjd_r1c-d16893e52540" class="topicref" data-id="task_fbj_hjd_r1c" data-state="leaf"><span role="button" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/Oracle.html#task_fbj_hjd_r1c" id="task_fbj_hjd_r1c-d16893e52540-link">Configuring an Oracle Destination</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li></ul></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_fq3_kpc_r2b-d16893e52564" class="topicref" data-id="concept_fq3_kpc_r2b" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_fq3_kpc_r2b-d16893e52564-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/PulsarProducer.html#concept_fq3_kpc_r2b" id="concept_fq3_kpc_r2b-d16893e52564-link">Pulsar Producer</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_pxj_rvy_dv-d16893e52779" class="topicref" data-id="concept_pxj_rvy_dv" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_pxj_rvy_dv-d16893e52779-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/RabbitMQ.html#concept_pxj_rvy_dv" id="concept_pxj_rvy_dv-d16893e52779-link">RabbitMQ Producer</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_ktc_gw2_gw-d16893e52847" class="topicref" data-id="concept_ktc_gw2_gw" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_ktc_gw2_gw-d16893e52847-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/Redis.html#concept_ktc_gw2_gw" id="concept_ktc_gw2_gw-d16893e52847-link">Redis</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_rlb_rt3_rx-d16893e52981" class="topicref" data-id="concept_rlb_rt3_rx" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_rlb_rt3_rx-d16893e52981-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/Salesforce.html#concept_rlb_rt3_rx" id="concept_rlb_rt3_rx-d16893e52981-link">Salesforce</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_q2c_hz2_zsb-d16893e53120" class="topicref" data-id="concept_q2c_hz2_zsb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_q2c_hz2_zsb-d16893e53120-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/SalesforceBAPI2.html#concept_q2c_hz2_zsb" id="concept_q2c_hz2_zsb-d16893e53120-link">Salesforce Bulk API 2.0 </a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_lfk_hx2_ct-d16893e53261" class="topicref" data-id="concept_lfk_hx2_ct" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_lfk_hx2_ct-d16893e53261-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/SDC_RPCdest.html#concept_lfk_hx2_ct" id="concept_lfk_hx2_ct-d16893e53261-link">SDC RPC (deprecated)</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_eyd_zx4_q2b-d16893e53357" class="topicref" data-id="concept_eyd_zx4_q2b" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_eyd_zx4_q2b-d16893e53357-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/SendResponse.html#concept_eyd_zx4_q2b" id="concept_eyd_zx4_q2b-d16893e53357-link">Send Response to Origin</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_sgt_m2m_xhb-d16893e53403" class="topicref" data-id="concept_sgt_m2m_xhb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_sgt_m2m_xhb-d16893e53403-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/SFTP.html#concept_sgt_m2m_xhb" id="concept_sgt_m2m_xhb-d16893e53403-link">SFTP/FTP/FTPS Client</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_rmn_3nj_twb-d16893e53543" class="topicref" data-id="concept_rmn_3nj_twb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_rmn_3nj_twb-d16893e53543-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/SingleStore.html#concept_rmn_3nj_twb" id="concept_rmn_3nj_twb-d16893e53543-link">SingleStore</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_vxl_zzc_1gb-d16893e53609" class="topicref" data-id="concept_vxl_zzc_1gb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_vxl_zzc_1gb-d16893e53609-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/Snowflake.html#concept_vxl_zzc_1gb" id="concept_vxl_zzc_1gb-d16893e53609-link">Snowflake</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_jmh_p25_4qb-d16893e54127" class="topicref" data-id="concept_jmh_p25_4qb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_jmh_p25_4qb-d16893e54127-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/SnowflakeFileUploader.html#concept_jmh_p25_4qb" id="concept_jmh_p25_4qb-d16893e54127-link">Snowflake File Uploader</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_z2g_q1r_wr-d16893e54337" class="topicref" data-id="concept_z2g_q1r_wr" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_z2g_q1r_wr-d16893e54337-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/Solr.html#concept_z2g_q1r_wr" id="concept_z2g_q1r_wr-d16893e54337-link">Solr</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_zzr_pqn_xdb-d16893e54436" class="topicref" data-id="concept_zzr_pqn_xdb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_zzr_pqn_xdb-d16893e54436-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/Splunk.html#concept_zzr_pqn_xdb" id="concept_zzr_pqn_xdb-d16893e54436-link">Splunk</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_hjv_5nn_r3b-d16893e54557" class="topicref" data-id="concept_hjv_5nn_r3b" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_hjv_5nn_r3b-d16893e54557-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/SQLServerBDCBulk.html#concept_hjv_5nn_r3b" id="concept_hjv_5nn_r3b-d16893e54557-link">SQL Server 2019 BDC Bulk Loader (deprecated)</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_idr_ct5_w2b-d16893e54822" class="topicref" data-id="concept_idr_ct5_w2b" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_idr_ct5_w2b-d16893e54822-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/Syslog.html#concept_idr_ct5_w2b" id="concept_idr_ct5_w2b-d16893e54822-link">Syslog</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_hlx_r53_rx-d16893e54984" class="topicref" data-id="concept_hlx_r53_rx" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_hlx_r53_rx-d16893e54984-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/TableauCRM.html#concept_hlx_r53_rx" id="concept_hlx_r53_rx-d16893e54984-link">Tableau CRM</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_ngm_jjf_b1c-d16893e55170" class="topicref" data-id="concept_ngm_jjf_b1c" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_ngm_jjf_b1c-d16893e55170-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/Teradata.html#concept_ngm_jjf_b1c" id="concept_ngm_jjf_b1c-d16893e55170-link">Teradata</a></div></div></li><li role="treeitem"><div data-tocid="concept_ryn_v3z_lr-d16893e55610" class="topicref" data-id="concept_ryn_v3z_lr" data-state="leaf"><span role="button" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/ToError.html" id="concept_ryn_v3z_lr-d16893e55610-link">To Error </a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem"><div data-tocid="concept_htf_ydj_wq-d16893e55634" class="topicref" data-id="concept_htf_ydj_wq" data-state="leaf"><span role="button" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/Trash.html#concept_htf_ydj_wq" id="concept_htf_ydj_wq-d16893e55634-link">Trash</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_nt1_slb_1zb-d16893e55658" class="topicref" data-id="concept_nt1_slb_1zb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_nt1_slb_1zb-d16893e55658-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/WebClient.html#concept_nt1_slb_1zb" id="concept_nt1_slb_1zb-d16893e55658-link">Web Client</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_l4d_mjn_lz-d16893e56003" class="topicref" data-id="concept_l4d_mjn_lz" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_l4d_mjn_lz-d16893e56003-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Destinations/WebSocketClient.html#concept_l4d_mjn_lz" id="concept_l4d_mjn_lz-d16893e56003-link">WebSocket Client</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li></ul></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_umc_1lk_fx-d16893e56072" class="topicref" data-id="concept_umc_1lk_fx" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_umc_1lk_fx-d16893e56072-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Executors/Executors-title.html" id="concept_umc_1lk_fx-d16893e56072-link">Executors</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_xxd_f5r_kx-d16893e59696" class="topicref" data-id="concept_xxd_f5r_kx" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_xxd_f5r_kx-d16893e59696-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Event_Handling/EventFramework-Title.html#concept_xxd_f5r_kx" id="concept_xxd_f5r_kx-d16893e59696-link">Dataflow Triggers</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_zq5_pb4_flb-d16893e60134" class="topicref" data-id="concept_zq5_pb4_flb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_zq5_pb4_flb-d16893e60134-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Solutions/Solutions-title.html" id="concept_zq5_pb4_flb-d16893e60134-link">Solutions</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_ugp_kwf_xw-d16893e61337" class="topicref" data-id="concept_ugp_kwf_xw" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_ugp_kwf_xw-d16893e61337-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/DPM/DPM_title.html" id="concept_ugp_kwf_xw-d16893e61337-link">StreamSets Control Hub</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_fyf_gkq_4bb-d16893e62693" class="topicref" data-id="concept_fyf_gkq_4bb" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_fyf_gkq_4bb-d16893e62693-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Edge_Mode/EdgePipelines_title.html" id="concept_fyf_gkq_4bb-d16893e62693-link"><span class="ph">StreamSets Data Collector Edge</span></a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_wwq_gxc_py-d16893e63980" class="topicref" data-id="concept_wwq_gxc_py" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_wwq_gxc_py-d16893e63980-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Multithreaded_Pipelines/MultithreadedPipelines.html#concept_wwq_gxc_py" id="concept_wwq_gxc_py-d16893e63980-link">Multithreaded Pipelines</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_gzw_tdm_p2b-d16893e64187" class="topicref" data-id="concept_gzw_tdm_p2b" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_gzw_tdm_p2b-d16893e64187-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Microservice/Microservice_Title.html#concept_gzw_tdm_p2b" id="concept_gzw_tdm_p2b-d16893e64187-link">Microservice Pipelines</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="Orchestrators_Title-d16893e64348" class="topicref" data-id="Orchestrators_Title" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action Orchestrators_Title-d16893e64348-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Orchestration_Pipelines/OrchestrationPipelines_Title.html#Orchestrators_Title" id="Orchestrators_Title-d16893e64348-link">Orchestration Pipelines</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_wr1_ktz_bt-d16893e64489" class="topicref" data-id="concept_wr1_ktz_bt" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_wr1_ktz_bt-d16893e64489-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/RPC_Pipelines/SDC_RPCpipelines_title.html#concept_wr1_ktz_bt" id="concept_wr1_ktz_bt-d16893e64489-link">SDC RPC Pipelines</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_fpz_5r4_vs-d16893e64679" class="topicref" data-id="concept_fpz_5r4_vs" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_fpz_5r4_vs-d16893e64679-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Cluster_Mode/ClusterPipelines_title.html" id="concept_fpz_5r4_vs-d16893e64679-link">Cluster Pipelines</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_jjk_23z_sq-d16893e65172" class="topicref" data-id="concept_jjk_23z_sq" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_jjk_23z_sq-d16893e65172-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Data_Preview/DataPreview_Title.html#concept_jjk_23z_sq" id="concept_jjk_23z_sq-d16893e65172-link">Data Preview</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_pgk_brx_rr-d16893e65458" class="topicref" data-id="concept_pgk_brx_rr" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_pgk_brx_rr-d16893e65458-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Alerts/RulesAlerts_title.html#concept_pgk_brx_rr" id="concept_pgk_brx_rr-d16893e65458-link">Rules and Alerts</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_asx_fdz_sq-d16893e65960" class="topicref" data-id="concept_asx_fdz_sq" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_asx_fdz_sq-d16893e65960-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Pipeline_Monitoring/PipelineMonitoring_title.html#concept_asx_fdz_sq" id="concept_asx_fdz_sq-d16893e65960-link">Pipeline Monitoring</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_o3l_dtr_5q-d16893e66304" class="topicref" data-id="concept_o3l_dtr_5q" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_o3l_dtr_5q-d16893e66304-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Pipeline_Maintenance/PipelineMaintenance_title.html#concept_o3l_dtr_5q" id="concept_o3l_dtr_5q-d16893e66304-link">Pipeline Maintenance</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_yms_ftm_sq-d16893e66768" class="topicref" data-id="concept_yms_ftm_sq" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_yms_ftm_sq-d16893e66768-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Administration/Administration_title.html#concept_yms_ftm_sq" id="concept_yms_ftm_sq-d16893e66768-link">Administration</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_nls_w1r_ks-d16893e67508" class="topicref" data-id="concept_nls_w1r_ks" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_nls_w1r_ks-d16893e67508-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Tutorial/Tutorial-title.html" id="concept_nls_w1r_ks-d16893e67508-link">Tutorial</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_sh3_frm_tq-d16893e68001" class="topicref" data-id="concept_sh3_frm_tq" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_sh3_frm_tq-d16893e68001-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Troubleshooting/Troubleshooting_title.html#concept_sh3_frm_tq" id="concept_sh3_frm_tq-d16893e68001-link">Troubleshooting</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_xbx_rs1_tq-d16893e68798" class="topicref" data-id="concept_xbx_rs1_tq" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_xbx_rs1_tq-d16893e68798-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Glossary/Glossary_title.html#concept_xbx_rs1_tq" id="concept_xbx_rs1_tq-d16893e68798-link">Glossary</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_jn1_nzb_kv-d16893e68843" class="topicref" data-id="concept_jn1_nzb_kv" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_jn1_nzb_kv-d16893e68843-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Apx-DataFormats/DataFormat_Title.html#concept_jn1_nzb_kv" id="concept_jn1_nzb_kv-d16893e68843-link">Data Formats by Stage</a><div class="wh-tooltip"><p class="shortdesc"></p></div></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_pvm_yt3_wq-d16893e68958" class="topicref" data-id="concept_pvm_yt3_wq" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_pvm_yt3_wq-d16893e68958-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Expression_Language/ExpressionLanguage_title.html" id="concept_pvm_yt3_wq-d16893e68958-link">Expression Language</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_vcj_1ws_js-d16893e69669" class="topicref" data-id="concept_vcj_1ws_js" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_vcj_1ws_js-d16893e69669-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Apx-RegEx/RegEx-Title.html#concept_vcj_1ws_js" id="concept_vcj_1ws_js-d16893e69669-link">Regular Expressions</a></div></div></li><li role="treeitem" aria-expanded="false"><div data-tocid="concept_chv_vmj_wr-d16893e69787" class="topicref" data-id="concept_chv_vmj_wr" data-state="not-ready"><span role="button" tabindex="0" aria-labelledby="button-expand-action concept_chv_vmj_wr-d16893e69787-link" class="wh-expand-btn"></span><div class="title"><a href="../../../datacollector/UserGuide/Apx-GrokPatterns/GrokPatterns_title.html#concept_chv_vmj_wr" id="concept_chv_vmj_wr-d16893e69787-link">Grok Patterns</a></div></div></li></ul></div>
                        

</div>
</nav>
                    


                    
                    <div id="wh_topic_body" class="col-lg-7 col-md-9 col-sm-12">
<button id="wh_close_publication_toc_button" class="close-toc-button d-none" aria-label="Toggle publishing table of content" aria-controls="wh_publication_toc" aria-expanded="true"><span class="close-toc-icon-container"><span class="close-toc-icon"></span></span></button><button id="wh_close_topic_toc_button" class="close-toc-button d-none" aria-label="Toggle topic table of content" aria-controls="wh_topic_toc" aria-expanded="true"><span class="close-toc-icon-container"><span class="close-toc-icon"></span></span></button>

                        
<div class=" wh_topic_content body "><main role="main"><article class="" role="article" aria-labelledby="ariaid-title1"><article class="nested0" aria-labelledby="ariaid-title1" id="concept_shv_2jd_r1c">
    <h1 class="- topic/title title topictitle1" id="ariaid-title1">Oracle</h1>
    
    <div class="- topic/body concept/conbody body conbody"><p class="- topic/shortdesc shortdesc"></p>
        <p class="- topic/p p">The Oracle destination writes data to tables in a Oracle database. <span class="- topic/ph ph">For information about supported versions, see <a class="- topic/xref xref" href="../Installation/SupportedSystemVersions.html#concept_s5h_bcr_n4b">Supported Systems and Versions</a>.</span></p>
        <p class="- topic/p p">You can use the Oracle destination to write new data or change data capture (CDC) data to
            Oracle. The destination writes data from record fields to table columns based on
            matching names. The destination can compensate for data drift by creating new columns
            and tables in Oracle when new fields and table references appear in records.</p>
        <p class="- topic/p p">The Oracle destination uses a JDBC connection string or Oracle host and service name to
            connect to the Oracle database. When you configure the destination, you specify the
            connection string or host and service name, and credentials to use to connect to the
            database. 
        </p>
        <p class="- topic/p p">You configure the Oracle database and tables to use, and specify error handling.</p>
        <p class="- topic/p p">You can optionally enable data drift. You can have the destination create new tables, as
            needed. You can also specify whether to create all new columns as String instead of
            inferring the type.</p>
        <p class="- topic/p p">Before you can use the Oracle destination, you must complete a <a class="- topic/xref xref" href="Oracle.html#concept_msy_vsl_fcc">prerequisite task</a>.</p>
    </div>
<article class="- topic/topic concept/concept topic concept nested1" aria-labelledby="ariaid-title2" id="concept_msy_vsl_fcc">
    <h2 class="- topic/title title topictitle2" id="ariaid-title2">Prerequisite</h2>
    
    <div class="- topic/body concept/conbody body conbody"><p class="- topic/shortdesc shortdesc"></p>
        <p class="- topic/p p">Before using the Oracle destination, install the Oracle JDBC driver for the database. The
            destination cannot access the database until you install this driver.</p>
        <div class="- topic/p p"><span class="- topic/ph ph">For information about installing additional drivers, <span class="- topic/ph ph" id="concept_msy_vsl_fcc__SDCDPM-ExtLibs-linksOnly">see <a class="- topic/xref xref" href="../Configuration/ExternalLibs.html#concept_pdv_qlw_ft">Install External Libraries</a>.</span></span><ol class="- topic/ol ol" id="concept_msy_vsl_fcc__ol_e2k_ddp_nhb" data-ofbid="concept_msy_vsl_fcc__ol_e2k_ddp_nhb">
                <li class="- topic/li li">Download the Oracle JDBC driver from the Oracle website.<div class="- topic/p p">
                        <div class="- topic/note note note note_note" id="concept_msy_vsl_fcc__note_p5l_qrd_pxb" data-ofbid="concept_msy_vsl_fcc__note_p5l_qrd_pxb"><span class="note__title">Note:</span> Writing XML data to Oracle requires installing
                            the Oracle Data Integrator Driver for XML. For more information, see the
                                <a class="- topic/xref xref" href="https://docs.oracle.com/cd/E29597_01/integrate.1111/e12644/xml_file.htm" target="_blank" rel="external noopener">Oracle documentation</a>.</div>
                    </div></li>
                <li class="- topic/li li">Install the driver as an external library into the JDBC branded Oracle stage
                    library, <code class="+ topic/ph pr-d/codeph ph codeph"><span class="- topic/ph ph">streamsets-datacollector-jdbc-branded-oracle-lib</span></code>, which includes the origin.</li>
            </ol></div>
    </div>
</article><article class="- topic/topic concept/concept topic concept nested1" aria-labelledby="ariaid-title3" id="concept_ntt_c2h_z1c">
    <h2 class="- topic/title title topictitle2" id="ariaid-title3">Enabling Data Drift Handling</h2>
    
    <div class="- topic/body concept/conbody body conbody"><p class="- topic/shortdesc shortdesc"></p>
        <p class="- topic/p p">The Oracle destination can automatically compensate for changes in column or table
            requirements, also known as <dfn class="- topic/term term">data drift</dfn>.</p>
        <div class="- topic/p p"><div class="- topic/note note note note_note" id="concept_ntt_c2h_z1c__note_d5n_njm_d1c" data-ofbid="concept_ntt_c2h_z1c__note_d5n_njm_d1c"><span class="note__title">Note:</span> If you change the destination table schema
                manually rather than enabling data drift handling, you must restart the pipeline to
                allow the destination to discover schema changes. </div>The destination can handle
            data drift in the following ways:<dl class="- topic/dl dl" id="concept_ntt_c2h_z1c__dl_e5n_njm_d1c" data-ofbid="concept_ntt_c2h_z1c__dl_e5n_njm_d1c">
                
                    <dt class="- topic/dt dt dlterm">Create new columns</dt>
                    <dd class="- topic/dd dd">
                        <p class="- topic/p p">The destination can create new columns in Oracle tables when new fields
                            appear in records. For example, if a record suddenly includes a new
                                <code class="+ topic/ph pr-d/codeph ph codeph">Address2</code> field, the destination creates a new
                                <code class="+ topic/ph pr-d/codeph ph codeph">Address2</code> column in the target table.</p>
                        <p class="- topic/p p">By default, the destination creates new columns based on the data in the
                            new fields, such as creating a Double column for decimal data. You can,
                            however, configure the destination to create all new columns as
                            String.</p>
                    </dd>
                    <dd class="- topic/dd dd ddexpand">To enable the automatic creation of new columns, select the
                            <span class="+ topic/ph ui-d/uicontrol ph uicontrol">Enable Data Drift</span> property on the
                            <span class="+ topic/ph ui-d/uicontrol ph uicontrol">JDBC</span> tab. To create new columns as String, select
                        the <span class="+ topic/ph ui-d/uicontrol ph uicontrol">Create New Columns as String</span> property.</dd>
                
                
                    <dt class="- topic/dt dt dlterm">Create new tables</dt>
                    <dd class="- topic/dd dd">The destination can <a class="- topic/xref xref" href="Oracle.html#concept_v5v_pfh_z1c">create new
                            tables</a> as needed. For example, say the destination writes data to
                        tables based on the region name in the <code class="+ topic/ph pr-d/codeph ph codeph">Region</code> field. When a
                        new <code class="+ topic/ph pr-d/codeph ph codeph">SW-3</code> region shows up in a record, the destination
                        creates a new <code class="+ topic/ph pr-d/codeph ph codeph">SW-3</code> table in Oracle and writes the record to
                        the new table.</dd>
                    <dd class="- topic/dd dd ddexpand">
                        <p class="- topic/p p">You can use this functionality to create all necessary tables in an empty
                            Oracle database schema.</p>
                    </dd>
                    <dd class="- topic/dd dd ddexpand">To enable the creation of new tables, select the <span class="+ topic/ph ui-d/uicontrol ph uicontrol">Auto Create
                            Table</span> property.</dd>
                
            </dl></div>
    </div>
<article class="- topic/topic concept/concept topic concept nested2" aria-labelledby="ariaid-title4" id="concept_z5f_s2h_z1c">
    <h3 class="- topic/title title topictitle3" id="ariaid-title4">Generated Data Types</h3>
    
    <div class="- topic/body concept/conbody body conbody"><p class="- topic/shortdesc shortdesc"></p>
        <p class="- topic/p p">When creating new tables or creating new columns in existing tables, the Oracle
            destination uses field names to generate the new column names. </p>
        <div class="- topic/p p">You can configure the destination to create all new columns as String. However, by
            default, the Oracle destination creates columns as follows:<div class="table-container"><table class="- topic/table table frame-all" id="concept_z5f_s2h_z1c__table_tkq_rgp_ggb" data-ofbid="concept_z5f_s2h_z1c__table_tkq_rgp_ggb" data-cols="2"><caption></caption><colgroup><col style="width:50%"/><col style="width:50%"/></colgroup><thead class="- topic/thead thead">
                        <tr class="- topic/row">
                            <th class="- topic/entry entry colsep-1 rowsep-1" id="concept_z5f_s2h_z1c__table_tkq_rgp_ggb__entry__1">Record Field Data Type</th>
                            <th class="- topic/entry entry colsep-0 rowsep-1" id="concept_z5f_s2h_z1c__table_tkq_rgp_ggb__entry__2">Oracle Column Data Type</th>
                        </tr>
                    </thead><tbody class="- topic/tbody tbody">
                        <tr class="- topic/row">
                            <td class="- topic/entry entry colsep-1 rowsep-1" headers="concept_z5f_s2h_z1c__table_tkq_rgp_ggb__entry__1">Byte Array</td>
                            <td class="- topic/entry entry colsep-0 rowsep-1" headers="concept_z5f_s2h_z1c__table_tkq_rgp_ggb__entry__2">Binary Float</td>
                        </tr>
                        <tr class="- topic/row">
                            <td class="- topic/entry entry colsep-1 rowsep-1" headers="concept_z5f_s2h_z1c__table_tkq_rgp_ggb__entry__1">Char</td>
                            <td class="- topic/entry entry colsep-0 rowsep-1" headers="concept_z5f_s2h_z1c__table_tkq_rgp_ggb__entry__2">Char</td>
                        </tr>
                        <tr class="- topic/row">
                            <td class="- topic/entry entry colsep-1 rowsep-1" headers="concept_z5f_s2h_z1c__table_tkq_rgp_ggb__entry__1">String</td>
                            <td class="- topic/entry entry colsep-0 rowsep-1" headers="concept_z5f_s2h_z1c__table_tkq_rgp_ggb__entry__2">Varchar2</td>
                        </tr>
                        <tr class="- topic/row">
                            <td class="- topic/entry entry colsep-1 rowsep-1" headers="concept_z5f_s2h_z1c__table_tkq_rgp_ggb__entry__1">Decimal</td>
                            <td class="- topic/entry entry colsep-0 rowsep-1" headers="concept_z5f_s2h_z1c__table_tkq_rgp_ggb__entry__2">Number</td>
                        </tr>
                        <tr class="- topic/row">
                            <td class="- topic/entry entry colsep-1 rowsep-1" headers="concept_z5f_s2h_z1c__table_tkq_rgp_ggb__entry__1">Long</td>
                            <td class="- topic/entry entry colsep-0 rowsep-1" headers="concept_z5f_s2h_z1c__table_tkq_rgp_ggb__entry__2">Long</td>
                        </tr>
                        <tr class="- topic/row">
                            <td class="- topic/entry entry colsep-1 rowsep-1" headers="concept_z5f_s2h_z1c__table_tkq_rgp_ggb__entry__1">Float</td>
                            <td class="- topic/entry entry colsep-0 rowsep-1" headers="concept_z5f_s2h_z1c__table_tkq_rgp_ggb__entry__2">Float</td>
                        </tr>
                        <tr class="- topic/row">
                            <td class="- topic/entry entry colsep-1 rowsep-1" headers="concept_z5f_s2h_z1c__table_tkq_rgp_ggb__entry__1">Integer</td>
                            <td class="- topic/entry entry colsep-0 rowsep-1" headers="concept_z5f_s2h_z1c__table_tkq_rgp_ggb__entry__2">Number</td>
                        </tr>
                        <tr class="- topic/row">
                            <td class="- topic/entry entry colsep-1 rowsep-1" headers="concept_z5f_s2h_z1c__table_tkq_rgp_ggb__entry__1">Short</td>
                            <td class="- topic/entry entry colsep-0 rowsep-1" headers="concept_z5f_s2h_z1c__table_tkq_rgp_ggb__entry__2">Number</td>
                        </tr>
                        <tr class="- topic/row">
                            <td class="- topic/entry entry colsep-1 rowsep-1" headers="concept_z5f_s2h_z1c__table_tkq_rgp_ggb__entry__1">Date</td>
                            <td class="- topic/entry entry colsep-0 rowsep-1" headers="concept_z5f_s2h_z1c__table_tkq_rgp_ggb__entry__2">Date</td>
                        </tr>
                        <tr class="- topic/row">
                            <td class="- topic/entry entry colsep-1 rowsep-1" headers="concept_z5f_s2h_z1c__table_tkq_rgp_ggb__entry__1">Datetime</td>
                            <td class="- topic/entry entry colsep-0 rowsep-1" headers="concept_z5f_s2h_z1c__table_tkq_rgp_ggb__entry__2">Timestamp</td>
                        </tr>
                        <tr class="- topic/row">
                            <td class="- topic/entry entry colsep-1 rowsep-1" headers="concept_z5f_s2h_z1c__table_tkq_rgp_ggb__entry__1">Zoned Datetime</td>
                            <td class="- topic/entry entry colsep-0 rowsep-1" headers="concept_z5f_s2h_z1c__table_tkq_rgp_ggb__entry__2">Timestamp With Time Zone</td>
                        </tr>
                        <tr class="- topic/row">
                            <td class="- topic/entry entry colsep-1 rowsep-0" headers="concept_z5f_s2h_z1c__table_tkq_rgp_ggb__entry__1">Double</td>
                            <td class="- topic/entry entry colsep-0 rowsep-0" headers="concept_z5f_s2h_z1c__table_tkq_rgp_ggb__entry__2">Float</td>
                        </tr>
                    </tbody></table></div></div>
        <p class="- topic/p p">The destination does not support nested <span class="- topic/ph ph">Data Collector</span>
            data types: List, List-Map, and Map. By default, the destination treats fields with
            invalid data types as an error record. You can configure the destination to ignore
            fields with invalid data types, replacing them with an empty value. </p>
        <div class="- topic/p p">
            <div class="- topic/note note tip note_tip" id="concept_z5f_s2h_z1c__note_a5r_jxs_d1c" data-ofbid="concept_z5f_s2h_z1c__note_a5r_jxs_d1c"><span class="note__title">Tip:</span> To process fields in a record including nested
                list, list-map or map fields, use a <a class="- topic/xref xref" href="../Processors/FieldFlattener.html#concept_njn_3kk_fx">Field Flattener
                    processor</a> to flatten the entire record to produce a record with no nested
                fields.</div>
        </div>
    </div>
</article></article><article class="- topic/topic concept/concept topic concept nested1" aria-labelledby="ariaid-title5" id="concept_v5v_pfh_z1c">
    <h2 class="- topic/title title topictitle2" id="ariaid-title5">Creating Tables</h2>
    
    <div class="- topic/body concept/conbody body conbody"><p class="- topic/shortdesc shortdesc"></p>
        <p class="- topic/p p">If you configure the Oracle destination to <a class="- topic/xref xref" href="Oracle.html#concept_ntt_c2h_z1c">handle
                data drift</a>, you can also configure the destination to create tables. Once
            configured, the destination creates tables when the specified or needed tables do not
            exist in Oracle. </p>
        <div class="- topic/p p">With the Auto Create Table property enabled on the JDBC tab, the destination creates
            tables and columns as follows:<dl class="- topic/dl dl" id="concept_v5v_pfh_z1c__dl_wl2_4lm_d1c" data-ofbid="concept_v5v_pfh_z1c__dl_wl2_4lm_d1c">
                
                    <dt class="- topic/dt dt dlterm">Table</dt>
                    <dd class="- topic/dd dd">The destination creates a table if the table specified in the Table Name
                        property does not exist. </dd>
                    <dd class="- topic/dd dd ddexpand">While handling data drift, the destination creates tables needed to write
                        records to tables that do not exist.</dd>
                
                
                    <dt class="- topic/dt dt dlterm">Table columns</dt>
                    <dd class="- topic/dd dd">In the created tables, the destination determines the columns from the first
                        batch of data processed. The destination infers the data types from the data
                        in the batch. </dd>
                    <dd class="- topic/dd dd ddexpand">The columns in the created tables are nullable.</dd>
                
            </dl></div>
    </div>
</article><article class="- topic/topic concept/concept topic concept nested1" aria-labelledby="ariaid-title6" id="concept_ezq_nhh_z1c">
    <h2 class="- topic/title title topictitle2" id="ariaid-title6">CRUD Operation Processing</h2>
    
    <div class="- topic/body concept/conbody body conbody"><p class="- topic/shortdesc shortdesc"></p>
        <p class="- topic/p p">The Oracle destination can insert, update, upsert, or delete data when you configure the
            destination to process CDC data.</p>
        <div class="- topic/p p">When writing data, the Oracle destination uses the CRUD operation specified in the
                <code class="+ topic/ph pr-d/codeph ph codeph">sdc.operation.type</code> record header attribute. The destination
            performs operations based on the following numeric values:<ul class="- topic/ul ul" id="concept_ezq_nhh_z1c__ul_vvx_wgj_ggb" data-ofbid="concept_ezq_nhh_z1c__ul_vvx_wgj_ggb">
                <li class="- topic/li li">1 for INSERT</li>
                <li class="- topic/li li">2 for DELETE</li>
                <li class="- topic/li li">3 for UPDATE</li>
                <li class="- topic/li li">4 for UPSERT</li>
            </ul></div>
        <p class="- topic/p p"><span class="- topic/ph ph">If
                                          your pipeline has a CRUD-enabled origin that processes
                                          changed data, the destination simply reads the operation
                                          type from the <code class="+ topic/ph pr-d/codeph ph codeph">sdc.operation.type</code> header
                                          attribute that the origin generates. If your pipeline has
                                          a non-CDC origin, you can use the Expression Evaluator
                                          processor or a scripting processor to define the record
                                          header attribute. For more information about <span class="- topic/ph ph">Data Collector</span> changed data processing and a list of CDC-enabled
                                          origins, see <a class="- topic/xref xref" href="../Pipeline_Design/CDC-Overview.html#concept_apw_l2c_ty">Processing Changed Data</a>.</span></p>
    </div>
</article><article class="- topic/topic task/task topic task nested1" aria-labelledby="ariaid-title7" id="task_fbj_hjd_r1c">
    <h2 class="- topic/title title topictitle2" id="ariaid-title7">Configuring an Oracle Destination</h2>
    
    <div class="- topic/body task/taskbody body taskbody"><p class="- topic/shortdesc shortdesc"></p>
        <section class="- topic/section task/context section context">
            <p class="- topic/p p">Configure an Oracle destination to write data to Oracle tables.</p>
        </section>
        <section class="- topic/ol task/steps ol steps"><ol class="- topic/ol task/steps ol steps" id="task_fbj_hjd_r1c__steps_s3k_5hh_ht" data-ofbid="task_fbj_hjd_r1c__steps_s3k_5hh_ht"><li class="- topic/li task/step li step">
                <span class="- topic/ph task/cmd ph cmd">In the Properties panel, on the <span class="+ topic/keyword ui-d/wintitle keyword wintitle">General</span> tab, configure the
                    following properties:</span>
                <div class="- topic/itemgroup task/info itemgroup info">
                    <div class="table-container"><table class="- topic/table table frame-all" id="task_fbj_hjd_r1c__table_blh_n2h_hr" data-ofbid="task_fbj_hjd_r1c__table_blh_n2h_hr" data-cols="2"><caption></caption><colgroup><col style="width:30%"/><col style="width:70%"/></colgroup><thead class="- topic/thead thead">
                                <tr class="- topic/row">
                                    <th class="- topic/entry entry colsep-1 rowsep-1" id="task_fbj_hjd_r1c__table_blh_n2h_hr__entry__1">General Property</th>
                                    <th class="- topic/entry entry colsep-0 rowsep-1" id="task_fbj_hjd_r1c__table_blh_n2h_hr__entry__2">Description</th>
                                </tr>
                            </thead><tbody class="- topic/tbody tbody">
                                <tr class="- topic/row" id="task_fbj_hjd_r1c__row_GenName">
                                    <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_fbj_hjd_r1c__table_blh_n2h_hr__entry__1">Name</td>
                                    <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_fbj_hjd_r1c__table_blh_n2h_hr__entry__2">Stage name.</td>
                                </tr>
                                <tr class="- topic/row" id="task_fbj_hjd_r1c__row_GenDesc">
                                    <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_fbj_hjd_r1c__table_blh_n2h_hr__entry__1">Description</td>
                                    <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_fbj_hjd_r1c__table_blh_n2h_hr__entry__2">Optional description.</td>
                                </tr>
                                <tr class="- topic/row" id="task_fbj_hjd_r1c__row_GenRequired">
                                    <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_fbj_hjd_r1c__table_blh_n2h_hr__entry__1"><a class="- topic/xref xref" href="../Pipeline_Design/DroppingUnwantedRecords.html#concept_dnj_bkm_vq">Required Fields</a></td>
                                    <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_fbj_hjd_r1c__table_blh_n2h_hr__entry__2">Fields that must include data for the record to be passed
                                        into the stage. <div class="- topic/note note tip note_tip"><span class="note__title">Tip:</span> You might
                                            include fields that the stage uses.</div><p class="- topic/p p">Records
                                            that do not include all required fields are processed
                                            based on the error handling configured for the
                                            pipeline.</p></td>
                                </tr>
                                <tr class="- topic/row" id="task_fbj_hjd_r1c__row_GenPreconditions">
                                    <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_fbj_hjd_r1c__table_blh_n2h_hr__entry__1"><a class="- topic/xref xref" href="../Pipeline_Design/DroppingUnwantedRecords.html#concept_msl_yd4_fs">Preconditions</a></td>
                                    <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_fbj_hjd_r1c__table_blh_n2h_hr__entry__2">Conditions that must evaluate to TRUE to allow a record
                                        to enter the stage for processing. Click
                                            <span class="+ topic/ph ui-d/uicontrol ph uicontrol">Add</span> to create additional
                                        preconditions. <p class="- topic/p p">Records that do not meet all preconditions
                                            are processed based on the error handling configured for
                                            the stage.</p></td>
                                </tr>
                                <tr class="- topic/row" id="task_fbj_hjd_r1c__row_GenRecError">
                                    <td class="- topic/entry entry colsep-1 rowsep-0" headers="task_fbj_hjd_r1c__table_blh_n2h_hr__entry__1"><a class="- topic/xref xref" href="../Pipeline_Design/ErrorHandling.html#concept_atr_j4y_5r">On Record Error</a></td>
                                    <td class="- topic/entry entry colsep-0 rowsep-0" headers="task_fbj_hjd_r1c__table_blh_n2h_hr__entry__2">Error record handling for the stage: <ul class="- topic/ul ul" id="task_fbj_hjd_r1c__ul_swp_lfh_hr" data-ofbid="task_fbj_hjd_r1c__ul_swp_lfh_hr">
                                            <li class="- topic/li li">Discard - Discards the record.</li>
                                            <li class="- topic/li li">Send to Error - Sends the record to the pipeline for
                                                error handling.</li>
                                            <li class="- topic/li li">Stop Pipeline - Stops the pipeline. Not valid for
                                                cluster pipelines.</li>
                                        </ul></td>
                                </tr>
                            </tbody></table></div>
                </div>
            </li><li class="- topic/li task/step li step">
                <span class="- topic/ph task/cmd ph cmd">On the <span class="+ topic/ph ui-d/uicontrol ph uicontrol">JDBC</span> tab, configure the following
                    properties:</span>
                <div class="- topic/itemgroup task/info itemgroup info">
                    <div class="table-container"><table class="- topic/table table frame-all" id="task_fbj_hjd_r1c__table_c1b_nhy_3t" data-ofbid="task_fbj_hjd_r1c__table_c1b_nhy_3t" data-cols="2"><caption></caption><colgroup><col style="width:30%"/><col style="width:70%"/></colgroup><thead class="- topic/thead thead">
                                <tr class="- topic/row">
                                    <th class="- topic/entry entry colsep-1 rowsep-1" id="task_fbj_hjd_r1c__table_c1b_nhy_3t__entry__1">JDBC Property</th>
                                    <th class="- topic/entry entry colsep-0 rowsep-1" id="task_fbj_hjd_r1c__table_c1b_nhy_3t__entry__2">Description</th>
                                </tr>
                            </thead><tbody class="- topic/tbody tbody">
                                
                                <tr class="- topic/row">
              <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_fbj_hjd_r1c__table_c1b_nhy_3t__entry__1">Hostname</td>
              <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_fbj_hjd_r1c__table_c1b_nhy_3t__entry__2">Host name of the database.</td>
            </tr>
                                <tr class="- topic/row">
              <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_fbj_hjd_r1c__table_c1b_nhy_3t__entry__1">Port</td>
              <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_fbj_hjd_r1c__table_c1b_nhy_3t__entry__2">Port number to use.</td>
            </tr>
                                <tr class="- topic/row">
              <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_fbj_hjd_r1c__table_c1b_nhy_3t__entry__1">Service Name</td>
              <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_fbj_hjd_r1c__table_c1b_nhy_3t__entry__2">Listener-registered service name. </td>
            </tr>
                                <tr class="- topic/row">
              <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_fbj_hjd_r1c__table_c1b_nhy_3t__entry__1">Use Connection String</td>
              <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_fbj_hjd_r1c__table_c1b_nhy_3t__entry__2">Use a JDBC connection string to connect to the Oracle database.</td>
            </tr>
                                <tr class="- topic/row">
              <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_fbj_hjd_r1c__table_c1b_nhy_3t__entry__1">Oracle JDBC Connection String</td>
              <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_fbj_hjd_r1c__table_c1b_nhy_3t__entry__2">Connection string used to connect to the database.<p class="- topic/p p">Enter the connection&#x2028;
                string in the following format:
                <code class="+ topic/ph pr-d/codeph ph codeph">jdbc:oracle:&lt;driver_type&gt;:@&lt;host&gt;:&lt;port&gt;:&lt;service_name&gt;</code></p><p class="- topic/p p">You
                  can optionally include the user name and password in the connection
                  string.</p><p class="- topic/p p">Required when Use Connection String is enabled.</p></td>
            </tr>
                                <tr class="- topic/row">
                                    <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_fbj_hjd_r1c__table_c1b_nhy_3t__entry__1">Schema Name</td>
                                    <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_fbj_hjd_r1c__table_c1b_nhy_3t__entry__2">Optional database or schema name to use. <div class="- topic/p p">Use when the
                                            database requires a fully-qualified table name. <div class="- topic/note note tip note_tip" id="task_fbj_hjd_r1c__note_xjb_t5s_y1c" data-ofbid="task_fbj_hjd_r1c__note_xjb_t5s_y1c"><span class="note__title">Tip:</span> <span class="- topic/ph ph">Oracle uses all caps for schema, table, and column names by
                        default. Names can be lower- or mixed-case only if the schema, table, or
                        column was created with quotation marks around the name.</span>
                                                <p class="- topic/p p">To use a lower- or mixed-case schema name, enter
                                                  the name and enable the Enclosed Object Names
                                                  property. </p></div></div></td>
                                </tr>
                                <tr class="- topic/row">
                                    <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_fbj_hjd_r1c__table_c1b_nhy_3t__entry__1">Table Name</td>
                                    <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_fbj_hjd_r1c__table_c1b_nhy_3t__entry__2">Database table name to use.<div class="- topic/p p">
                                            <div class="- topic/note note tip note_tip" id="task_fbj_hjd_r1c__note_yjb_t5s_y1c" data-ofbid="task_fbj_hjd_r1c__note_yjb_t5s_y1c"><span class="note__title">Tip:</span> <span class="- topic/ph ph">Oracle uses all caps for schema, table, and column names by
                        default. Names can be lower- or mixed-case only if the schema, table, or
                        column was created with quotation marks around the name.</span><p class="- topic/p p">To use a lower- or mixed-case table name,
                                                  enter the name and enable the Enclosed Object
                                                  Names property. </p></div>
                                        </div></td>
                                </tr>
                                <tr class="- topic/row">
                                    <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_fbj_hjd_r1c__table_c1b_nhy_3t__entry__1"><a class="- topic/xref xref" href="Oracle.html#concept_ntt_c2h_z1c">Enable Data
                                            Drift</a></td>
                                    <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_fbj_hjd_r1c__table_c1b_nhy_3t__entry__2">Enables the stage to create new columns in Oracle tables when new fields appear in records.</td>
                                </tr>
                                <tr class="- topic/row">
                                    <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_fbj_hjd_r1c__table_c1b_nhy_3t__entry__1"><a class="- topic/xref xref" href="Oracle.html#concept_v5v_pfh_z1c">Auto Create
                                            Table</a></td>
                                    <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_fbj_hjd_r1c__table_c1b_nhy_3t__entry__2">Automatically creates tables when needed. <p class="- topic/p p">Available when data drift is enabled. </p></td>
                                </tr>
                                <tr class="- topic/row">
                        <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_fbj_hjd_r1c__table_c1b_nhy_3t__entry__1">Use Credentials</td>
                        <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_fbj_hjd_r1c__table_c1b_nhy_3t__entry__2"><span class="- topic/ph ph" id="task_fbj_hjd_r1c__ph_UseCredentialsDesc">Enables entering credentials on the
                                Credentials tab. Select when you do not include credentials in the
                                JDBC connection string.</span></td>
                    </tr>
                                <tr class="- topic/row">
              <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_fbj_hjd_r1c__table_c1b_nhy_3t__entry__1">Field to Column Mapping</td>
              <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_fbj_hjd_r1c__table_c1b_nhy_3t__entry__2">Use to override the default field to column mappings. By default, fields are
                written to columns of the same name.<div class="- topic/p p">When you override the mappings, you can
                  define parameterized values to apply SQL functions to the field values before
                  writing them to columns. For example, to convert a field value to an integer,
                  enter the following for the parameterized
                  value:<pre class="+ topic/pre pr-d/codeblock pre codeblock"><code>CAST(? AS INTEGER)</code></pre></div><p class="- topic/p p">The question mark (?) is
                  substituted with the value of the field. Leave the default value of ? if you do
                  not need to apply a SQL function.</p><p class="- topic/p p">Using <a class="- topic/xref xref" href="../Pipeline_Configuration/SimpleBulkEdit.html#concept_alb_b3y_cbb">simple or bulk edit mode</a>, click the <span class="+ topic/ph ui-d/uicontrol ph uicontrol">Add</span> icon to
                  create additional field to column mappings.</p></td>
            </tr>
                                <tr class="- topic/row">
              <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_fbj_hjd_r1c__table_c1b_nhy_3t__entry__1">Change Log Format</td>
              <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_fbj_hjd_r1c__table_c1b_nhy_3t__entry__2">Format of change capture data log produced by the CDC-enabled origin. Used to
                process change capture data. </td>
            </tr>
                                <tr class="- topic/row">
                                    <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_fbj_hjd_r1c__table_c1b_nhy_3t__entry__1"><a class="- topic/xref xref" href="Oracle.html#concept_ezq_nhh_z1c">Default
                                            Operation</a></td>
                                    <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_fbj_hjd_r1c__table_c1b_nhy_3t__entry__2">Default CRUD operation to
                                        perform if the <code class="+ topic/ph pr-d/codeph ph codeph">sdc.operation.type</code> record
                                        header attribute is not set. </td>
                                </tr>
                                <tr class="- topic/row">
                                    <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_fbj_hjd_r1c__table_c1b_nhy_3t__entry__1"><a class="- topic/xref xref" href="Oracle.html#concept_ezq_nhh_z1c">Unsupported
                                            Operation Handling </a></td>
                                    <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_fbj_hjd_r1c__table_c1b_nhy_3t__entry__2">Action to take when the
                                        CRUD operation type defined in the
                                            <code class="+ topic/ph pr-d/codeph ph codeph">sdc.operation.type</code> record header
                                        attribute is not supported:<ul class="- topic/ul ul" id="task_fbj_hjd_r1c__ul_UnsupportedOperationHandlingCRUD" data-ofbid="task_fbj_hjd_r1c__ul_UnsupportedOperationHandlingCRUD">
                                            <li class="- topic/li li">Discard - Discards the record.</li>
                                            <li class="- topic/li li">Send to Error - Sends the record to the pipeline for
                                                error handling.</li>
                                            <li class="- topic/li li">Use Default Operation - Writes the record to the
                                                destination system using the default operation.</li>
                                        </ul></td>
                                </tr>
                                <tr class="- topic/row">
              <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_fbj_hjd_r1c__table_c1b_nhy_3t__entry__1">Rollback Batch On Error</td>
              <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_fbj_hjd_r1c__table_c1b_nhy_3t__entry__2">Rolls back the entire batch when an error occurs within the batch. </td>
            </tr>
                                <tr class="- topic/row">
              <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_fbj_hjd_r1c__table_c1b_nhy_3t__entry__1">Use Quoted Identifiers</td>
              <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_fbj_hjd_r1c__table_c1b_nhy_3t__entry__2">Encloses table and column names in quotation marks.<p class="- topic/p p">When this property is disabled, the destination uses the standard naming conventions for Oracle.</p></td>
            </tr>
                                <tr class="- topic/row">
                                    <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_fbj_hjd_r1c__table_c1b_nhy_3t__entry__1">Create New Columns as String</td>
                                    <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_fbj_hjd_r1c__table_c1b_nhy_3t__entry__2">Creates all new columns as String. By default, the
                                        destination creates new columns based on the <a class="- topic/xref xref" href="Oracle.html#concept_z5f_s2h_z1c">type of
                                            data</a> in the field. <p class="- topic/p p">Available when data drift
                                            is enabled.</p></td>
                                </tr>
                                <tr class="- topic/row">
              <td class="- topic/entry entry colsep-1 rowsep-0" headers="task_fbj_hjd_r1c__table_c1b_nhy_3t__entry__1">Additional JDBC Configuration Properties</td>
              <td class="- topic/entry entry colsep-0 rowsep-0" headers="task_fbj_hjd_r1c__table_c1b_nhy_3t__entry__2">Additional JDBC configuration properties to use. To add properties, click
                  <span class="+ topic/ph ui-d/uicontrol ph uicontrol">Add</span> and define the JDBC property name and value. <p class="- topic/p p">Use the
                  property names and values as expected by JDBC. </p></td>
            </tr>
                            </tbody></table></div>
                </div>
            </li><li class="- topic/li task/step li step">
                <span class="- topic/ph task/cmd ph cmd" id="task_fbj_hjd_r1c__CMD-CredentialsTab">If you configured the destination to use credentials
                    separately from the Oracle JDBC connection string on the
                        <span class="+ topic/keyword ui-d/wintitle keyword wintitle">JDBC</span> tab, then configure the following properties on
                    the <span class="+ topic/keyword ui-d/wintitle keyword wintitle">Credentials</span> tab:</span>
                <div class="- topic/itemgroup task/info itemgroup info">
                    <div class="table-container"><table class="- topic/table table frame-all" id="task_fbj_hjd_r1c__tbl-JDBCcredentials" data-ofbid="task_fbj_hjd_r1c__tbl-JDBCcredentials" data-cols="2"><caption></caption><colgroup><col style="width:30%"/><col style="width:70%"/></colgroup><thead class="- topic/thead thead">
                                <tr class="- topic/row" id="task_fbj_hjd_r1c__row-CredentialsTabHeading">
                                    <th class="- topic/entry entry colsep-1 rowsep-1" id="task_fbj_hjd_r1c__row-CredentialsTabHeading__entry__1">Credentials Property</th>
                                    <th class="- topic/entry entry colsep-0 rowsep-1" id="task_fbj_hjd_r1c__row-CredentialsTabHeading__entry__2">Description</th>
                                </tr>
                            </thead><tbody class="- topic/tbody tbody">
                                <tr class="- topic/row">
                        <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_fbj_hjd_r1c__row-CredentialsTabHeading__entry__1">Username</td>
                        <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_fbj_hjd_r1c__row-CredentialsTabHeading__entry__2"><span class="- topic/ph ph">User name for the JDBC connection.</span><p class="- topic/p p"><span class="- topic/ph ph">The user account must have the correct
                                    permissions or privileges in the database. </span>
                            </p></td>
                    </tr>
                                <tr class="- topic/row">
                                    <td class="- topic/entry entry colsep-1 rowsep-0" headers="task_fbj_hjd_r1c__row-CredentialsTabHeading__entry__1">Password</td>
                                    <td class="- topic/entry entry colsep-0 rowsep-0" headers="task_fbj_hjd_r1c__row-CredentialsTabHeading__entry__2"><span class="- topic/ph ph">Password for
                                the JDBC user name. </span><div class="- topic/note note tip note_tip" id="task_fbj_hjd_r1c__note_whx_tny_y1c" data-ofbid="task_fbj_hjd_r1c__note_whx_tny_y1c"><span class="note__title">Tip:</span> <span class="- topic/ph ph" id="task_fbj_hjd_r1c__ph-runtimeresources_credstores">To
                        secure sensitive information such as user names and passwords, you can use
                              <a class="- topic/xref xref" href="../Pipeline_Configuration/RuntimeValues.html#concept_bs4_5nm_2s" title="Similar to runtime properties, runtime resources are values that you define in a file local to the Data Collector and call from within a pipeline. But with runtime resources, you can restrict the permissions for the files to secure information.">runtime resources</a> or <span class="- topic/ph ph"><a class="- topic/xref xref" href="../Configuration/CredentialStores.html#concept_bt1_bpj_r1b">credential stores.</a></span></span></div></td>
                                </tr>
                            </tbody></table></div>
                </div>
            </li><li class="- topic/li task/step li step" id="task_fbj_hjd_r1c__JDBC-Advanced" data-ofbid="task_fbj_hjd_r1c__JDBC-Advanced">
                <span class="- topic/ph task/cmd ph cmd">On the <span class="+ topic/keyword ui-d/wintitle keyword wintitle">Advanced</span> tab, optionally configure advanced
                    properties.</span>
                <div class="- topic/itemgroup task/info itemgroup info">The defaults for these properties should work in most cases:<div class="table-container"><table class="- topic/table table frame-all" id="task_fbj_hjd_r1c__table_wnj_hf3_p5" data-ofbid="task_fbj_hjd_r1c__table_wnj_hf3_p5" data-cols="2"><caption></caption><colgroup><col style="width:30%"/><col style="width:70%"/></colgroup><thead class="- topic/thead thead">
                                <tr class="- topic/row">
                                    <th class="- topic/entry entry colsep-1 rowsep-1" id="task_fbj_hjd_r1c__table_wnj_hf3_p5__entry__1">Advanced Property</th>
                                    <th class="- topic/entry entry colsep-0 rowsep-1" id="task_fbj_hjd_r1c__table_wnj_hf3_p5__entry__2">Description</th>
                                </tr>
                            </thead><tbody class="- topic/tbody tbody">
                                <tr class="- topic/row">
              <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_fbj_hjd_r1c__table_wnj_hf3_p5__entry__1">Maximum Pool Size </td>
              <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_fbj_hjd_r1c__table_wnj_hf3_p5__entry__2">Maximum number of connections to create. <p class="- topic/p p">Default is 1. The recommended value
                  is 1.</p></td>
            </tr>
                                <tr class="- topic/row">
              <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_fbj_hjd_r1c__table_wnj_hf3_p5__entry__1">Minimum Idle Connections</td>
              <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_fbj_hjd_r1c__table_wnj_hf3_p5__entry__2">Minimum number of connections to create and maintain. To define a fixed
                connection pool, set to the same value as Maximum Pool Size. <p class="- topic/p p">Default is 1.
                </p></td>
            </tr>
                                <tr class="- topic/row">
              <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_fbj_hjd_r1c__table_wnj_hf3_p5__entry__1">Connection Timeout (seconds)</td>
              <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_fbj_hjd_r1c__table_wnj_hf3_p5__entry__2">Maximum time to wait for a connection. Use a time constant in an expression to
                define the time increment. <div class="- topic/p p">Default is 30 seconds, defined as follows:
                  <pre class="+ topic/pre pr-d/codeblock pre codeblock"><code>${30 * SECONDS}</code></pre></div></td>
            </tr>
                                <tr class="- topic/row">
              <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_fbj_hjd_r1c__table_wnj_hf3_p5__entry__1">Idle Timeout (seconds)</td>
              <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_fbj_hjd_r1c__table_wnj_hf3_p5__entry__2">Maximum time to allow a connection to idle. Use a time constant in an
                expression to define the time increment. <p class="- topic/p p">Use 0 to avoid removing any idle
                  connections.</p><p class="- topic/p p">When the entered value is close to or more than the maximum
                  lifetime for a connection, <span class="- topic/ph ph">Data Collector</span> ignores the idle
                  timeout.</p><div class="- topic/p p">Default is 10 minutes, defined as follows:
                  <pre class="+ topic/pre pr-d/codeblock pre codeblock"><code>${10 * MINUTES}</code></pre></div></td>
            </tr>
                                <tr class="- topic/row">
              <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_fbj_hjd_r1c__table_wnj_hf3_p5__entry__1">Max Connection Lifetime (seconds)</td>
              <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_fbj_hjd_r1c__table_wnj_hf3_p5__entry__2">Maximum lifetime for a connection. Use a time constant in an expression to
                define the time increment. <p class="- topic/p p">Use 0 to set no maximum lifetime.</p><p class="- topic/p p">When a maximum
                  lifetime is set, the minimum valid value is 30 minutes.</p><div class="- topic/p p">Default is 30
                  minutes, defined as follows: <pre class="+ topic/pre pr-d/codeblock pre codeblock"><code>${30 * MINUTES}</code></pre></div></td>
            </tr>
                                <tr class="- topic/row">
              <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_fbj_hjd_r1c__table_wnj_hf3_p5__entry__1">Transaction Isolation</td>
              <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_fbj_hjd_r1c__table_wnj_hf3_p5__entry__2">Transaction isolation level used to connect to the database. <p class="- topic/p p">Default is the
                  default transaction isolation level set for the database. You can override the
                  database default by setting the level to any of the following:</p><ul class="- topic/ul ul" id="task_fbj_hjd_r1c__ul_arc_mdf_2y" data-ofbid="task_fbj_hjd_r1c__ul_arc_mdf_2y">
                  <li class="- topic/li li">Read committed </li>
                  <li class="- topic/li li">Read uncommitted </li>
                  <li class="- topic/li li">Repeatable read</li>
                  <li class="- topic/li li">Serializable</li>
                </ul></td>
            </tr>
                                <tr class="- topic/row">
              <td class="- topic/entry entry colsep-1 rowsep-1" id="task_fbj_hjd_r1c__advanced-InitQuery-property" headers="task_fbj_hjd_r1c__table_wnj_hf3_p5__entry__1">Init Query</td>
              <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_fbj_hjd_r1c__table_wnj_hf3_p5__entry__2"><span class="- topic/ph ph" id="task_fbj_hjd_r1c__InitQuery-desc-s1">SQL query to perform immediately after the stage
                  connects to the database. Use to set up the database session as needed. </span><p class="- topic/p p" id="task_fbj_hjd_r1c__InitQuery-desc-s2" data-ofbid="task_fbj_hjd_r1c__InitQuery-desc-s2">The query is performed after each connection to the
                  database. If the stage disconnects from the database during the pipeline run, for
                  example if a network timeout occurrs, the stage performs the query again when it
                  reconnects to the database. </p><p class="- topic/p p">For example, in case of Oracle, the following
                  query returns 1 to verify that the stage is connected to the database:
                    <code class="+ topic/ph pr-d/codeph ph codeph">Select 1 from dual;</code></p></td>
            </tr>
                                <tr class="- topic/row">
                                    <td class="- topic/entry entry colsep-1 rowsep-0" headers="task_fbj_hjd_r1c__table_wnj_hf3_p5__entry__1">Data SQLSTATE Codes</td>
                                    <td class="- topic/entry entry colsep-0 rowsep-0" headers="task_fbj_hjd_r1c__table_wnj_hf3_p5__entry__2">List of SQLSTATE codes to treat as data errors. The
                                        destination applies error record handling to records that
                                        trigger a listed code. <p class="- topic/p p">When a record triggers a SQLSTATE
                                            code not listed, the destination generates a stage error
                                            that stops the pipeline.</p><p class="- topic/p p">To add a code, click
                                                <span class="+ topic/ph ui-d/uicontrol ph uicontrol">Add</span> and enter the
                                        code.</p></td>
                                </tr>
                            </tbody></table></div></div>
            </li><li class="- topic/li task/step li step">
                <span class="- topic/ph task/cmd ph cmd">On the <span class="+ topic/keyword ui-d/wintitle keyword wintitle">Data</span> tab, configure the following properties:</span>
                <div class="- topic/itemgroup task/info itemgroup info">
                    <div class="table-container"><table class="- topic/table table frame-all" id="task_fbj_hjd_r1c__table_apw_myz_tbc" data-ofbid="task_fbj_hjd_r1c__table_apw_myz_tbc" data-cols="2"><caption></caption><colgroup><col style="width:30%"/><col style="width:70%"/></colgroup><thead class="- topic/thead thead">
            <tr class="- topic/row">
              <th class="- topic/entry entry colsep-1 rowsep-1" id="task_fbj_hjd_r1c__table_apw_myz_tbc__entry__1">Data Property</th>
              <th class="- topic/entry entry colsep-0 rowsep-1" id="task_fbj_hjd_r1c__table_apw_myz_tbc__entry__2">Description</th>
            </tr>
          </thead><tbody class="- topic/tbody tbody">
            <tr class="- topic/row" id="task_fbj_hjd_r1c__row-ColumnFieldsIgnore">
              <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_fbj_hjd_r1c__table_apw_myz_tbc__entry__1">Column Fields to Ignore</td>
              <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_fbj_hjd_r1c__table_apw_myz_tbc__entry__2">A list of fields to ignore when writing to the destination. You can enter a comma-separated list of first-level fields to ignore.</td>
            </tr>
            <tr class="- topic/row">
              <td class="- topic/entry entry colsep-1 rowsep-1" id="task_fbj_hjd_r1c__entry-IgnoreFieldsInvalid" headers="task_fbj_hjd_r1c__table_apw_myz_tbc__entry__1">Ignore Fields with Invalid Type</td>
              <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_fbj_hjd_r1c__table_apw_myz_tbc__entry__2">Allows replacing fields that contain data of an <a class="- topic/xref xref" href="Oracle.html#concept_z5f_s2h_z1c">invalid type</a> with an empty value.<p class="- topic/p p"><span class="- topic/ph ph" id="task_fbj_hjd_r1c__ph-IngoreFieldsInvalid-desc">When not enabled, records with data of invalid types are treated as error records.</span></p></td>
            </tr>
            <tr class="- topic/row" id="task_fbj_hjd_r1c__row-MergeCDCData">
              <td class="- topic/entry entry colsep-1 rowsep-0" headers="task_fbj_hjd_r1c__table_apw_myz_tbc__entry__1">Merge CDC Data</td>
              <td class="- topic/entry entry colsep-0 rowsep-0" headers="task_fbj_hjd_r1c__table_apw_myz_tbc__entry__2">Enables performing CRUD operations and using the MERGE command to write to Oracle tables. Select to process CDC data. <div class="- topic/p p"><div class="- topic/note note important note_important" id="task_fbj_hjd_r1c__note_wdt_gdh_z1c" data-ofbid="task_fbj_hjd_r1c__note_wdt_gdh_z1c"><span class="note__title">Important:</span> To maintain the original order of data, do not use multiple threads or cluster execution mode when processing CDC data.</div></div></td>
            </tr>
          </tbody></table></div>
                </div>
            </li><li class="- topic/li task/step li step">
                <span class="- topic/ph task/cmd ph cmd">On the <span class="+ topic/keyword ui-d/wintitle keyword wintitle">SSL/TLS Encryption</span> tab, configure the following
                    properties:</span>
                <div class="- topic/itemgroup task/info itemgroup info">
                    <div class="table-container"><table class="- topic/table table frame-all" id="task_fbj_hjd_r1c__table_jlx_szz_tbc" data-ofbid="task_fbj_hjd_r1c__table_jlx_szz_tbc" data-cols="2"><caption></caption><colgroup><col style="width:30%"/><col style="width:70%"/></colgroup><thead class="- topic/thead thead">
            <tr class="- topic/row">
              <th class="- topic/entry entry colsep-1 rowsep-1" id="task_fbj_hjd_r1c__table_jlx_szz_tbc__entry__1">SSL/TLS Property</th>
              <th class="- topic/entry entry colsep-0 rowsep-1" id="task_fbj_hjd_r1c__table_jlx_szz_tbc__entry__2">Description</th>
            </tr>
          </thead><tbody class="- topic/tbody tbody">
            <tr class="- topic/row">
              <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_fbj_hjd_r1c__table_jlx_szz_tbc__entry__1">Encrypt Connection</td>
              <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_fbj_hjd_r1c__table_jlx_szz_tbc__entry__2">Encrypt the connection using SSL.</td>
            </tr>
            <tr class="- topic/row">
              <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_fbj_hjd_r1c__table_jlx_szz_tbc__entry__1">Server Certificate PEM</td>
              <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_fbj_hjd_r1c__table_jlx_szz_tbc__entry__2">Server certificate in PEM format used to verify the SSL/TLS certificate of the
                Oracle server.<p class="- topic/p p">Use a text editor to open the PEM encoded certificate, and then
                  copy and paste the full contents of the file into the property, including the
                  header and footer.</p></td>
            </tr>
            <tr class="- topic/row">
                                    <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_fbj_hjd_r1c__table_jlx_szz_tbc__entry__1">Cipher Suites</td>
                                    <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_fbj_hjd_r1c__table_jlx_szz_tbc__entry__2">Cipher suites to use. To use a cipher suite that is not a
                                        part of the default set, click the
                                            <span class="+ topic/ph ui-d/uicontrol ph uicontrol">Add</span> icon and enter the name of
                                        the cipher suite. You can use simple or bulk edit mode to
                                        add cipher suites.<p class="- topic/p p">Enter the Java Secure Socket Extension
                                            (JSSE) name for the additional cipher suites that you
                                            want to use. </p></td>
                                </tr>
            <tr class="- topic/row">
              <td class="- topic/entry entry colsep-1 rowsep-1" headers="task_fbj_hjd_r1c__table_jlx_szz_tbc__entry__1">Verify Hostname</td>
              <td class="- topic/entry entry colsep-0 rowsep-1" headers="task_fbj_hjd_r1c__table_jlx_szz_tbc__entry__2">Verify that the host name specified in the connection string matches the certificate name in the server certificate.</td>
            </tr>
            <tr class="- topic/row">
              <td class="- topic/entry entry colsep-1 rowsep-0" headers="task_fbj_hjd_r1c__table_jlx_szz_tbc__entry__1">SSL Distinguished Name</td>
              <td class="- topic/entry entry colsep-0 rowsep-0" headers="task_fbj_hjd_r1c__table_jlx_szz_tbc__entry__2">Distinguished Name (DN) of the server. This must match the DN in the server certificate.</td>
            </tr>
          </tbody></table></div>
                </div>
            </li></ol></section>
    </div>
</article></article></article></main></div>

                        
                        
                        


                    </div>
                    
                </div>
            </div>


        </div> <nav class="navbar navbar-default wh_footer" data-whc_version="25.0">
  <div class=" footer-container  mx-auto">
    <!-- script for Data Collector, all flavors, but only used when accessed directly, not from portal --><script>
  (function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
  (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
  m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
  })(window,document,'script','https://www.google-analytics.com/analytics.js','ga');

  ga('create', 'UA-60917135-3', 'auto');
  ga('send', 'pageview');
</script>
  </div>
</nav>

        
        <div id="go2top">
            <span class="oxy-icon oxy-icon-up"></span>
        </div>
        
        <!-- The modal container for images -->
        <div id="modal_img_large" class="modal">
            <span class="close oxy-icon oxy-icon-remove"></span>
            <!-- Modal Content (The Image) -->
            <div id="modal_img_container"></div>
            <!-- Modal Caption (Image Text) -->
            <div id="caption"></div>
        </div>
        
        
        Â© 2023 StreamSets, Inc.

    </body>
</html>